CREATE TABLE [dbo].[Source_Codes]
(
[SOURCE_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Source_Codes_SOURCE_CODE] DEFAULT (''),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Source_Codes_CAMPAIGN_CODE] DEFAULT (''),
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Source_Codes_TITLE] DEFAULT (''),
[DESCRIPTION] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [iSource_CodesSOURCE_CODE] ON [dbo].[Source_Codes] ([SOURCE_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Source_Codes] TO [IMIS]
GRANT SELECT ON  [dbo].[Source_Codes] TO [IMIS]
GRANT INSERT ON  [dbo].[Source_Codes] TO [IMIS]
GRANT DELETE ON  [dbo].[Source_Codes] TO [IMIS]
GRANT UPDATE ON  [dbo].[Source_Codes] TO [IMIS]
GO